@echo off
echo ---------------------------------------
echo Creating login roles and database
echo ---------------------------------------
psql -U postgres -f db/setup.sql
echo.
echo ---------------------------------------
echo Importing schema
echo ---------------------------------------
psql -d unswthink -U postgres -f db/schema.sql
echo.
echo ---------------------------------------
echo Applying user privileges
echo ---------------------------------------
psql -d unswthink -U postgres -f db/privileges.sql
echo.
echo ---------------------------------------
pause